﻿
CREATE PROCEDURE [dbo].[SYS_ServiceConfiguration_FetchModelByService]
(
	@Service  varchar(50)
)

AS

SELECT 		
	c.[ConfigurationId],
	c.[Service],
	c.[Type],
	c.[Value],
	c.[Status]
    FROM dbo.SYS_ServiceConfiguration c
	WHERE c.[Service]=@Service
	ORDER BY c.UpdateDate DESC

